﻿CREATE TABLE [dbo].[CategoryGroup]
(
	[CategoryGroupId] int IDENTITY(1,1) NOT NULL, 
	[GroupAlias] [nvarchar](30) NOT NULL,
	[Name] [varchar] (150) NOT NULL,
    [DateCreated] [datetime] NOT NULL,
    [CreatedBy] [varchar] (50) NOT NULL,
    [DateUpdated] [datetime] NOT NULL,
    [UpdatedBy] [varchar] (50) NOT NULL,
    CONSTRAINT [PK_CategoryGroup] PRIMARY KEY CLUSTERED 
    (
	    [CategoryGroupId] ASC
    )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON)
) ON [PRIMARY]
